# Load data

zip_cbsa_data <- read_csv(url('https://raw.githubusercontent.com/cyouh95/third-way-report/master/assets/data/zip_code_cbsa.csv'))
hs_data <- read_csv(url('https://github.com/cyouh95/third-way-report/blob/master/assets/data/hs_data.csv?raw=true'), col_types = c('zip_code' = 'c'))

ceeb_nces <- read_csv(url('https://github.com/mpatricia01/public_requests_eda/raw/main/data/ceeb_nces_crosswalk.csv'))
cds_nces <- read_csv(url('https://github.com/mpatricia01/public_requests_eda/raw/main/data/CDS_NCES_crosswalk.csv')) %>% 
  mutate(ncessch = str_c(NCESDist, NCESSchool))

load(url('https://github.com/mpatricia01/public_requests_eda/raw/main/data/145637_orders.RData'))
# Contains: IL_orders, OOS_orders, OOS_eng_orders, OOS_noneng_orders, intl_orders,
#           lists_df_pivot, lists_df_sat, lists_df_act, df_sat_ca_20, df_sat_ca_19

# Add 11 + 12 columns for the SAT test takers datasets
add_testtakers_cols <- function(sat_df) {
  sat_df %>% mutate(
    Enroll1112 = as.numeric(Enroll12) + as.numeric(Enroll11),
    NumTSTTakr1112 = NumTSTTakr11 + NumTSTTakr12,
    NumERWBenchmark1112 = as.numeric(NumERWBenchmark11) + as.numeric(NumERWBenchmark12),
    PctERWBenchmark1112 = as.numeric(PctERWBenchmark11) + as.numeric(PctERWBenchmark12),
    NumMathBenchmark1112 = as.numeric(NumMathBenchmark11) + as.numeric(NumMathBenchmark12),
    PctMathBenchmark1112 = as.numeric(PctMathBenchmark11) + as.numeric(PctMathBenchmark12),
    TotNumBothBenchmark1112 = as.numeric(TotNumBothBenchmark11) + as.numeric(TotNumBothBenchmark12),
    PctBothBenchmark1112 = as.numeric(PctBothBenchmark11) + as.numeric(PctBothBenchmark12)
  )
}

df_sat_ca_20 <- add_testtakers_cols(df_sat_ca_20)
df_sat_ca_19 <- add_testtakers_cols(df_sat_ca_19)

1 Illinois purchases (51 orders)

IL_orders
## # A tibble: 51 x 25
##    univ_id po_num   order_num order_title                 order_cost num_runs num_students date_start date_end   hs_grad_class  state_name cbsa_name race_ethnicity                                                                                                                                                                                                                       sat_score_min sat_score_max sat_score_old_min sat_score_old_max psat_score_min psat_score_max psat_score_old_min psat_score_old_max gpa_high gpa_low rank_high     rank_low    
##    <chr>   <chr>    <chr>     <chr>                            <dbl>    <dbl>        <dbl> <date>     <date>     <chr>          <chr>      <chr>     <chr>                                                                                                                                                                                                                                        <dbl>         <dbl>             <dbl>             <dbl>          <dbl>          <dbl>              <dbl>              <dbl> <chr>    <chr>   <chr>         <chr>       
##  1 145637  P1558959 327699    IL Lower Range August 2017      4611.        NA        10723 2017-10-12 NA         2018|2019|2020 Illinois   NA        Asian (including Indian subcontinent and Philippines origin)|Other|I do not wish to respond to race|No, not of Hispanic, Latino, or Spanish origin|White (including Middle Eastern origin)|Native Hawaiian or Other Pacific Islander          1160          1270              1090              1200           1160           1270                109                120 A+       B-      Highest tenth Second fifth
##  2 145637  P1558959 327649    IL Middle 50% August 2017       1762.        NA         4097 2017-10-12 NA         2018|2019|2020 Illinois   NA        Asian (including Indian subcontinent and Philippines origin)|Other|I do not wish to respond to race|No, not of Hispanic, Latino, or Spanish origin|White (including Middle Eastern origin)|Native Hawaiian or Other Pacific Islander          1280          1440              1210              1390           1280           1440                121                139 A+       B-      Highest tenth Second fifth
##  3 145637  P1558959 327696    IL 1450+ August 2017             241.        NA          561 2017-10-12 NA         2018|2019|2020 Illinois   NA        Asian (including Indian subcontinent and Philippines origin)|Other|I do not wish to respond to race|No, not of Hispanic, Latino, or Spanish origin|White (including Middle Eastern origin)|Native Hawaiian or Other Pacific Islander          1450          1600              1400              1600           1450           1520                140                149 A+       B-      Highest tenth Second fifth
##  4 145637  P1558959 327681    URM Lower Range August 2017     2859.        NA         6648 2017-10-12 NA         2018|2019|2020 Illinois   NA        Black or African American|American Indian or Alaska Native|Other Hispanic or Latino|Puerto Rican|Mexican|Hispanic or Latino (including Spanish origin)|Cuban                                                                                  1020          1190               940              1120           1020           1190                 94                112 A+       B-      Highest tenth Second fifth
##  5 145637  P1558959 327700    PAP Traditional August 2017      110.        NA          255 2017-10-12 NA         2018|2019|2020 Illinois   NA        Black or African American|American Indian or Alaska Native|Other Hispanic or Latino|Puerto Rican|Mexican|Hispanic or Latino (including Spanish origin)|Cuban                                                                                  1200          1380              1130              1320           1200           1380                113                132 A+       B-      Highest tenth Second fifth
##  6 145637  P1558959 327630    PAP Honors August 2017            11.6       NA           27 2017-10-12 NA         2018|2019|2020 Illinois   NA        Black or African American|American Indian or Alaska Native|Other Hispanic or Latino|Puerto Rican|Mexican|Hispanic or Latino (including Spanish origin)|Cuban                                                                                  1390          1600              1330              1600           1390           1520                133                149 A+       B-      Highest tenth Second fifth
##  7 145637  P1558959 371076    IL 1160-1270 Feb 2018           4849.        NA        11277 2018-02-06 NA         2019|2021|2020 Illinois   NA        Asian (including Indian subcontinent and Philippines origin)|Other|I do not wish to respond to race|No, not of Hispanic, Latino, or Spanish origin|White (including Middle Eastern origin)|Native Hawaiian or Other Pacific Islander          1160          1270              1090              1200           1160           1270                109                120 A+       B-      Highest tenth Second fifth
##  8 145637  P1558959 371072    IL 1280-1440 Feb 2018           1819.        NA         4230 2018-02-06 NA         2019|2021|2020 Illinois   NA        Asian (including Indian subcontinent and Philippines origin)|Other|I do not wish to respond to race|No, not of Hispanic, Latino, or Spanish origin|White (including Middle Eastern origin)|Native Hawaiian or Other Pacific Islander          1280          1440              1210              1390           1280           1440                121                139 A+       B-      Highest tenth Second fifth
##  9 145637  P1558959 371132    IL 1450+ Feb 2018                218.        NA          506 2018-02-06 NA         2019|2021|2020 Illinois   NA        Asian (including Indian subcontinent and Philippines origin)|Other|I do not wish to respond to race|No, not of Hispanic, Latino, or Spanish origin|White (including Middle Eastern origin)|Native Hawaiian or Other Pacific Islander          1450          1600              1400              1600           1450           1520                140                149 A+       B-      Highest tenth Second fifth
## 10 145637  P1558959 371079    URM 1020-1190 Feb 2018          2669.        NA         6207 2018-02-06 NA         2019|2021|2020 Illinois   NA        Black or African American|American Indian or Alaska Native|Other Hispanic or Latino|Puerto Rican|Mexican|Hispanic or Latino (including Spanish origin)|Cuban                                                                                  1020          1190               940              1120           1020           1190                 94                112 A+       B-      Highest tenth Second fifth
## # … with 41 more rows

Generally, on each purchase date, they make 6 IL orders by race/ethnicity and test scores:

  • Race/ethnicity groups (A) + Test score range (low A)
  • Race/ethnicity groups (A) + Test score range (med A)
  • Race/ethnicity groups (A) + Test score range (high A)
  • Race/ethnicity groups (B) + Test score range (low B)
  • Race/ethnicity groups (B) + Test score range (med B)
  • Race/ethnicity groups (B) + Test score range (high B)

Group/filter definitions:

  • Race/ethnicity groups (A)
    • Asian (including Indian subcontinent and Philippines origin)|Other|I do not wish to respond to race|No, not of Hispanic, Latino, or Spanish origin|White (including Middle Eastern origin)|Native Hawaiian or Other Pacific Islander
      • Starting from Fall 2019, they removed “Native Hawaiian or Other Pacific Islander” from the med and high orders
      • In the most recent 2 rounds of purchases (6 orders from Dec 2019 & Apr 2020), they further limited geographic filter to 12 specific metro areas within IL
    • Test score range (low A): 1160 - 1270
    • Test score range (med A): 1260/1280 - 1440
    • Test score range (high A): 1450 - 1600
  • Race/ethnicity groups (B)
    • Black or African American|American Indian or Alaska Native|Other Hispanic or Latino|Puerto Rican|Mexican|Hispanic or Latino (including Spanish origin)|Cuban
      • Starting from Fall 2019, they added “Native Hawaiian or Other Pacific Islander” to all orders (low, med, and high)
    • Test score range (low B): 1020/1030 - 1190
    • Test score range (med B): 1200 - 1350/1380
    • Test score range (high B): 1360/1390 - 1600

Common filters:

  • GPA: A+ to B-
  • Class rank: Highest tenth to second fifth

2 Out-of-states purchases (22 orders)

Based on geographic filters, we can categorize their orders into 3 broad categories:

  • Specific MSAs (3 orders)
  • Non-engineering majors in specific MSAs + CA, CT, MO, and Armed Forces military districts (6 orders)
  • Engineering majors in all 49 states except IL + DC (13 orders)

21 of the 22 out-of-state orders also use these segment analysis filters (total possible: 33 neighborhood clusters and 29 high-school clusters):

  • EN:51, HS:65 | EN:51, HS:68 | EN:51, HS:70 | EN:51, HS:79
  • EN:53, HS:65 | EN:53, HS:70 |
  • EN:58, HS:64 | EN:58, HS:65 | EN:58, HS:70
  • EN:60, HS:65 | EN:60, HS:68 | EN:60, HS:70 | EN:60, HS:79
  • EN:61, HS:ALL
  • EN:63, HS:65 | EN:63, HS:70
  • EN:69, HS:68 | EN:69, HS:70 | EN:69, HS:75
  • EN:70, HS:66 | EN:70, HS:68 | EN:70, HS:70 | EN:70, HS:79
  • EN:73, HS:65 | EN:73, HS:70
  • EN:78, HS:ALL

Sample neighborhood clusters (EN) characteristics from 2011:

Sample high school clusters (HS) characteristics from 2011:

2.1 MSA orders (3 orders)

OOS_msa_orders <- OOS_orders %>% filter(order_num %in% c('500590', '567376', '483751'))

OOS_msa_orders
## # A tibble: 3 x 23
##   univ_id po_num   order_num order_title             order_cost num_runs num_students date_start hs_grad_class       state_name cbsa_name                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               segment                                                                                                                                                                                                                                                                                                                                             gender sat_score_min sat_score_max sat_score_old_min sat_score_old_max psat_score_min psat_score_max psat_score_old_min psat_score_old_max gpa_high gpa_low
##   <chr>   <chr>    <chr>     <chr>                        <dbl>    <dbl>        <dbl> <date>     <chr>               <chr>      <chr>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   <chr>                                                                                                                                                                                                                                                                                                                                               <chr>          <dbl>         <dbl>             <dbl>             <dbl>          <dbl>          <dbl>              <dbl>              <dbl> <chr>    <chr>  
## 1 145637  P1887010 500590    OOS Regional MSAs           11273.        4        23985 2019-09-04 2021|2020|2023|2022 NA         NY - Syracuse, NY|FL - Orlando-Kissimmee-Sanford, FL|FL - Sebring, FL|GA - Warner Robins, GA|GA - Dalton, GA|CA - Bakersfield, CA|TX - San Angelo, TX|TX - College Station-Bryan, TX|GA - Valdosta, GA|FL - Palm Bay-Melbourne-Titusville, FL|GA - Columbus, GA-AL|FL - Port St. Lucie, FL|GA - Savannah, GA|CA - Visalia-Porterville, CA|NY - Rochester, NY|CA - Santa Rosa, CA|CA - Chico, CA|GA - Macon-Bibb County, GA|FL - Tampa-St. Petersburg-Clearwater, FL|GA - Chattanooga, TN-GA|GA - Brunswick, GA|FL - Gainesville, FL|TX - Midland, TX|FL - Cape Coral-Fort Myers, FL|FL - Crestview-Fort Walton Beach-Destin, FL|FL - Punta Gorda, FL|CA - San Diego-Carlsbad, CA|CA - Oxnard-Thousand Oaks-Ventura, CA|TX - Beaumont-Port Arthur, TX|GA - Albany, GA|GA - Hinesville, GA|FL - North Port-Sarasota-Bradenton, FL|FL - Jacksonville, FL|TX - San Antonio-New Braunfels, TX|TX - Killeen-Temple, TX|TX - Abilene, TX|GA - Atlanta-Sandy Springs-Roswell, GA|NJ - New York-Newark-Jersey City, NY-NJ-PA|FL - Ocala, FL|NJ - Vineland-Bridgeton, NJ|FL - Deltona-Daytona Beach-Ormond Beach, FL|TX - Waco, TX|NY - Buffalo-Cheektowaga-Niagara Falls, NY|GA - Augusta-Richmond County, GA-SC|TX - Sherman-Denison, TX|NY - Glens Falls, NY|FL - Lakeland-Winter Haven, FL|CA - San Luis Obispo-Paso Robles-Arroyo Grande, CA|CA - Vallejo-Fairfield, CA|TX - Texarkana, TX-AR|CA - San Francisco-Oakland-Hayward, CA|TX - Laredo, TX|FL - Homosassa Springs, FL|CA - Stockton-Lodi, CA|CA - Modesto, CA|TX - Odessa, TX|TX - Lubbock, TX|NY - Albany-Schenectady-Troy, NY|CA - Riverside-San Bernardino-Ontario, CA|GA - Gainesville, GA|TX - Amarillo, TX|GA - Rome, GA|CA - Sacramento--Roseville--Arden-Arcade, CA|FL - Tallahassee, FL|FL - Miami-Fort Lauderdale-West Palm Beach, FL|FL - Naples-Immokalee-Marco Island, FL|NJ - Philadelphia-Camden-Wilmington, PA-NJ-DE-MD|FL - Sebastian-Vero Beach, FL|CA - Santa Cruz-Watsonville, CA|NY - Watertown-Fort Drum, NY|CA - San Jose-Sunnyvale-Santa Clara, CA|CA - Madera, CA|NY - New York-Newark-Jersey City, NY-NJ-PA|TX - Brownsville-Harlingen, TX|FL - The Villages, FL|CA - El Centro, CA|NJ - Trenton, NJ|TX - Corpus Christi, TX|NJ - Atlantic City-Hammonton, NJ|NY - Ithaca, NY|NY - Binghamton, NY|TX - El Paso, TX|TX - McAllen-Edinburg-Mission, TX|FL - Panama City, FL|TX - Houston-The Woodlands-Sugar Land, TX|CA - Santa Maria-Santa Barbara, CA|CA - Hanford-Corcoran, CA|CA - Salinas, CA|CA - Yuba City, CA|CA - Fresno, CA|NJ - Ocean City, NJ|FL - Pensacola-Ferry Pass-Brent, FL|CA - Los Angeles-Long Beach-Anaheim, CA|TX - Dallas-Fort Worth-Arlington, TX|TX - Wichita Falls, TX|NY - Elmira, NY|CA - Redding, CA|TX - Longview, TX|TX - Austin-Round Rock, TX|NY - Utica-Rome, NY|CA - Napa, CA|TX - Tyler, TX|CA - Merced, CA|TX - Victoria, TX|NY - Kingston, NY|GA - Athens-Clarke County, GA|NJ - Allentown-Bethlehem-Easton, PA-NJ EN:51, HS:68|EN:58, HS:70|EN:53, HS:70|EN:51, HS:65|EN:69, HS:70|EN:60, HS:68|EN:73, HS:70|EN:60, HS:65|EN:69, HS:68|EN:70, HS:68|EN:63, HS:70|EN:70, HS:66|EN:78, HS:ALL|EN:58, HS:65|EN:58, HS:64|EN:51, HS:79|EN:60, HS:70|EN:51, HS:70|EN:53, HS:65|EN:60, HS:79|EN:69, HS:75|EN:70, HS:70|EN:63, HS:65|EN:61, HS:ALL|EN:73, HS:65|EN:70, HS:79 NA              1240          1450              1170              1400           1220           1450                115                140 A+       B-     
## 2 145637  P1887010 567376    OOS Regional MSAs           10980.       NA        23361 2020-04-03 2021|2023|2022      NA         NY - Syracuse, NY|FL - Orlando-Kissimmee-Sanford, FL|FL - Sebring, FL|GA - Warner Robins, GA|GA - Dalton, GA|CA - Bakersfield, CA|TX - San Angelo, TX|TX - College Station-Bryan, TX|GA - Valdosta, GA|FL - Palm Bay-Melbourne-Titusville, FL|GA - Columbus, GA-AL|FL - Port St. Lucie, FL|GA - Savannah, GA|CA - Visalia-Porterville, CA|NY - Rochester, NY|CA - Santa Rosa, CA|CA - Chico, CA|GA - Macon-Bibb County, GA|FL - Tampa-St. Petersburg-Clearwater, FL|GA - Chattanooga, TN-GA|GA - Brunswick, GA|FL - Gainesville, FL|TX - Midland, TX|FL - Cape Coral-Fort Myers, FL|FL - Crestview-Fort Walton Beach-Destin, FL|FL - Punta Gorda, FL|CA - San Diego-Carlsbad, CA|CA - Oxnard-Thousand Oaks-Ventura, CA|TX - Beaumont-Port Arthur, TX|GA - Albany, GA|GA - Hinesville, GA|FL - North Port-Sarasota-Bradenton, FL|FL - Jacksonville, FL|TX - San Antonio-New Braunfels, TX|TX - Killeen-Temple, TX|TX - Abilene, TX|GA - Atlanta-Sandy Springs-Roswell, GA|NJ - New York-Newark-Jersey City, NY-NJ-PA|FL - Ocala, FL|NJ - Vineland-Bridgeton, NJ|FL - Deltona-Daytona Beach-Ormond Beach, FL|TX - Waco, TX|NY - Buffalo-Cheektowaga-Niagara Falls, NY|GA - Augusta-Richmond County, GA-SC|TX - Sherman-Denison, TX|NY - Glens Falls, NY|FL - Lakeland-Winter Haven, FL|CA - San Luis Obispo-Paso Robles-Arroyo Grande, CA|CA - Vallejo-Fairfield, CA|TX - Texarkana, TX-AR|CA - San Francisco-Oakland-Hayward, CA|TX - Laredo, TX|FL - Homosassa Springs, FL|CA - Stockton-Lodi, CA|CA - Modesto, CA|TX - Odessa, TX|TX - Lubbock, TX|NY - Albany-Schenectady-Troy, NY|CA - Riverside-San Bernardino-Ontario, CA|GA - Gainesville, GA|TX - Amarillo, TX|GA - Rome, GA|CA - Sacramento--Roseville--Arden-Arcade, CA|FL - Tallahassee, FL|FL - Miami-Fort Lauderdale-West Palm Beach, FL|FL - Naples-Immokalee-Marco Island, FL|NJ - Philadelphia-Camden-Wilmington, PA-NJ-DE-MD|FL - Sebastian-Vero Beach, FL|CA - Santa Cruz-Watsonville, CA|NY - Watertown-Fort Drum, NY|CA - San Jose-Sunnyvale-Santa Clara, CA|CA - Madera, CA|NY - New York-Newark-Jersey City, NY-NJ-PA|TX - Brownsville-Harlingen, TX|FL - The Villages, FL|CA - El Centro, CA|NJ - Trenton, NJ|TX - Corpus Christi, TX|NJ - Atlantic City-Hammonton, NJ|NY - Ithaca, NY|NY - Binghamton, NY|TX - El Paso, TX|TX - McAllen-Edinburg-Mission, TX|FL - Panama City, FL|TX - Houston-The Woodlands-Sugar Land, TX|CA - Santa Maria-Santa Barbara, CA|CA - Hanford-Corcoran, CA|CA - Salinas, CA|CA - Yuba City, CA|CA - Fresno, CA|NJ - Ocean City, NJ|FL - Pensacola-Ferry Pass-Brent, FL|CA - Los Angeles-Long Beach-Anaheim, CA|TX - Dallas-Fort Worth-Arlington, TX|TX - Wichita Falls, TX|NY - Elmira, NY|CA - Redding, CA|TX - Longview, TX|TX - Austin-Round Rock, TX|NY - Utica-Rome, NY|CA - Napa, CA|TX - Tyler, TX|CA - Merced, CA|TX - Victoria, TX|NY - Kingston, NY|GA - Athens-Clarke County, GA|NJ - Allentown-Bethlehem-Easton, PA-NJ EN:51, HS:68|EN:58, HS:70|EN:53, HS:70|EN:51, HS:65|EN:69, HS:70|EN:60, HS:68|EN:73, HS:70|EN:60, HS:65|EN:69, HS:68|EN:70, HS:68|EN:63, HS:70|EN:70, HS:66|EN:78, HS:ALL|EN:58, HS:65|EN:58, HS:64|EN:51, HS:79|EN:60, HS:70|EN:51, HS:70|EN:53, HS:65|EN:60, HS:79|EN:69, HS:75|EN:70, HS:70|EN:63, HS:65|EN:61, HS:ALL|EN:73, HS:65|EN:70, HS:79 NA              1240          1450              1170              1400           1220           1450                115                140 A+       B-     
## 3 145637  P1659111 483751    Regional Counselor MSAs       674.       NA         1497 2019-06-27 2021|2022           NA         FL - Orlando-Kissimmee-Sanford, FL|FL - Sebring, FL|GA - Warner Robins, GA|GA - Dalton, GA|CA - Bakersfield, CA|TX - San Angelo, TX|TX - College Station-Bryan, TX|GA - Valdosta, GA|FL - Palm Bay-Melbourne-Titusville, FL|GA - Columbus, GA-AL|FL - Port St. Lucie, FL|GA - Savannah, GA|CA - Visalia-Porterville, CA|CA - Santa Rosa, CA|CA - Chico, CA|GA - Macon-Bibb County, GA|FL - Tampa-St. Petersburg-Clearwater, FL|GA - Chattanooga, TN-GA|GA - Brunswick, GA|FL - Gainesville, FL|TX - Midland, TX|FL - Cape Coral-Fort Myers, FL|FL - Crestview-Fort Walton Beach-Destin, FL|FL - Punta Gorda, FL|CA - San Diego-Carlsbad, CA|CA - Oxnard-Thousand Oaks-Ventura, CA|TX - Beaumont-Port Arthur, TX|GA - Albany, GA|GA - Hinesville, GA|FL - North Port-Sarasota-Bradenton, FL|FL - Jacksonville, FL|TX - San Antonio-New Braunfels, TX|TX - Killeen-Temple, TX|TX - Abilene, TX|GA - Atlanta-Sandy Springs-Roswell, GA|NJ - New York-Newark-Jersey City, NY-NJ-PA|FL - Ocala, FL|NJ - Vineland-Bridgeton, NJ|FL - Deltona-Daytona Beach-Ormond Beach, FL|TX - Waco, TX|GA - Augusta-Richmond County, GA-SC|TX - Sherman-Denison, TX|FL - Lakeland-Winter Haven, FL|CA - San Luis Obispo-Paso Robles-Arroyo Grande, CA|CA - Vallejo-Fairfield, CA|TX - Texarkana, TX-AR|CA - San Francisco-Oakland-Hayward, CA|TX - Laredo, TX|FL - Homosassa Springs, FL|CA - Stockton-Lodi, CA|CA - Modesto, CA|TX - Odessa, TX|TX - Lubbock, TX|CA - Riverside-San Bernardino-Ontario, CA|GA - Gainesville, GA|TX - Amarillo, TX|GA - Rome, GA|CA - Sacramento--Roseville--Arden-Arcade, CA|FL - Tallahassee, FL|FL - Miami-Fort Lauderdale-West Palm Beach, FL|FL - Naples-Immokalee-Marco Island, FL|NJ - Philadelphia-Camden-Wilmington, PA-NJ-DE-MD|FL - Sebastian-Vero Beach, FL|CA - Santa Cruz-Watsonville, CA|CA - San Jose-Sunnyvale-Santa Clara, CA|CA - Madera, CA|NY - New York-Newark-Jersey City, NY-NJ-PA|TX - Brownsville-Harlingen, TX|FL - The Villages, FL|CA - El Centro, CA|NJ - Trenton, NJ|TX - Corpus Christi, TX|NJ - Atlantic City-Hammonton, NJ|TX - El Paso, TX|TX - McAllen-Edinburg-Mission, TX|FL - Panama City, FL|TX - Houston-The Woodlands-Sugar Land, TX|CA - Santa Maria-Santa Barbara, CA|CA - Hanford-Corcoran, CA|CA - Salinas, CA|CA - Yuba City, CA|CA - Fresno, CA|NJ - Ocean City, NJ|FL - Pensacola-Ferry Pass-Brent, FL|CA - Los Angeles-Long Beach-Anaheim, CA|TX - Dallas-Fort Worth-Arlington, TX|TX - Wichita Falls, TX|CA - Redding, CA|TX - Longview, TX|TX - Austin-Round Rock, TX|CA - Napa, CA|TX - Tyler, TX|CA - Merced, CA|TX - Victoria, TX|GA - Athens-Clarke County, GA|NJ - Allentown-Bethlehem-Easton, PA-NJ                                                                                                                                                                                                                                                              EN:51, HS:68|EN:58, HS:70|EN:53, HS:70|EN:51, HS:65|EN:69, HS:70|EN:60, HS:68|EN:73, HS:70|EN:60, HS:65|EN:69, HS:68|EN:70, HS:68|EN:63, HS:70|EN:70, HS:66|EN:78, HS:ALL|EN:58, HS:65|EN:58, HS:64|EN:51, HS:79|EN:60, HS:70|EN:51, HS:70|EN:53, HS:65|EN:60, HS:79|EN:69, HS:75|EN:70, HS:70|EN:63, HS:65|EN:61, HS:ALL|EN:73, HS:65|EN:70, HS:79 NA              1240          1450              1170              1400           1240           1450                117                140 A+       B-

They made 2 “OOS Regional MSA” orders 1 “Regional Counselor MSAs” order.

  • They used the segment analysis from above
  • A+/B- high school GPA
  • MSAs from states: CA, TX, GA, FL, NY, NJ

2.1.1 Student-level MSA specific orders

Number of students purchased in the three orders

OOS_msa_stu %>% count(order_num) %>% arrange(-n)
## # A tibble: 3 x 2
##   order_num     n
##   <chr>     <int>
## 1 500590    35058
## 2 567376    23356
## 3 483751     1497

It appears that 4 students might of been purchased twice

OOS_msa_stu %>%
  group_by(Ref, order_num) %>%
  summarize(n_per_grp = n()) %>%
  ungroup() %>%
  count(n_per_grp)
## # A tibble: 2 x 2
##   n_per_grp     n
##       <int> <int>
## 1         1 59903
## 2         2     4
OOS_msa_stu %>%
  group_by(Ref, order_num) %>%
  summarize(n_per_grp = n()) %>%
  ungroup() %>%
  filter(n_per_grp > 1) #4 students were purchased twice
## # A tibble: 4 x 3
##   Ref       order_num n_per_grp
##   <chr>     <chr>         <int>
## 1 058607977 567376            2
## 2 058918440 567376            2
## 3 313230561 567376            2
## 4 964290266 500590            2

This table below shows the number of zip codes purchased by descending order

  • Grouped by zip code and summarized to get a count of the number of students purchased within each zip code
  • Merged in census zip-code level data to show demographic data associated with each zip code
OOS_msa_zip %>%
  dplyr::select(zip_code, n_per_grp, median_household_income, starts_with("pct"))
## # A tibble: 2,427 x 11
##    zip_code n_per_grp median_household_income pct_black pct_white pct_asian pct_latinx pct_nat_am pct_nat_hi pct_two_races pct_other
##    <chr>        <int>                   <dbl>     <dbl>     <dbl>     <dbl>      <dbl>      <dbl>      <dbl>         <dbl>     <dbl>
##  1 77494          565                  137231    0.0808     0.523    0.172      0.197    0.00743     0              0.0181  0.00162 
##  2 77479          485                  133200    0.0715     0.397    0.421      0.0859   0.000456    0              0.0218  0.00202 
##  3 94582          331                  140210    0.0258     0.304    0.554      0.0590   0.000865    0.00457        0.0507  0.00131 
##  4 77382          318                  136957    0.0187     0.721    0.0588     0.185    0           0.00181        0.0123  0.00267 
##  5 30024          284                  102181    0.0802     0.582    0.233      0.0774   0.00230     0              0.0208  0.00510 
##  6 75025          281                  109257    0.0732     0.552    0.281      0.0707   0.00142     0              0.0187  0.00263 
##  7 75013          280                  122010    0.0661     0.613    0.227      0.0594   0.00242     0              0.0270  0.00522 
##  8 75035          272                  118550    0.0900     0.592    0.181      0.105    0.00308     0.00153        0.0256  0.00170 
##  9 76092          271                  187670    0.0329     0.800    0.0829     0.0611   0.00377     0              0.0189  0.000617
## 10 75019          235                  114642    0.0439     0.605    0.213      0.111    0.00348     0              0.0219  0.00120 
## # … with 2,417 more rows

Filtered to the top five zip codes purchased

  • Calculated the race/ethnicity for students purchased by zip code to create percent race/ethnicity variables

Zip code 77494

  • Filtered to the zip code 77494 to compare the racial/ethnic composition of students purchased in this zip code and the racial/ethnic composition of the population of this zip code
OOS_msa_77494_zip <- OOS_msa_top_5_zip %>%
  filter(zip_code == "77494") %>%
  dplyr::select(zip_code, stu_pct_white, pct_white, stu_pct_black, pct_black, stu_pct_asian, pct_asian, stu_pct_latinx, pct_latinx, stu_pct_nhpi, pct_nat_hi, stu_pct_natam, pct_nat_am) %>% head(n=1)

OOS_msa_77494_zip
## # A tibble: 1 x 13
## # Groups:   zip_code [1]
##   zip_code stu_pct_white pct_white stu_pct_black pct_black stu_pct_asian pct_asian stu_pct_latinx pct_latinx stu_pct_nhpi pct_nat_hi stu_pct_natam pct_nat_am
##   <chr>            <dbl>     <dbl>         <dbl>     <dbl>         <dbl>     <dbl>          <dbl>      <dbl>        <dbl>      <dbl>         <dbl>      <dbl>
## 1 77494            0.311     0.523        0.0470    0.0808         0.420     0.172          0.179      0.197            0          0             0    0.00743

Zip code 77479

  • Filtered to the zip code 77479 to compare the racial/ethnic composition of students purchased in this zip code and the racial/ethnic composition of the population of this zip code
OOS_msa_77479_zip <- OOS_msa_top_5_zip %>%
  filter(zip_code == "77479") %>%
  dplyr::select(zip_code, stu_pct_white, pct_white, stu_pct_black, pct_black, stu_pct_asian, pct_asian, stu_pct_latinx, pct_latinx, stu_pct_nhpi, pct_nat_hi, stu_pct_natam, pct_nat_am) %>% head(n=1)

OOS_msa_77479_zip
## # A tibble: 1 x 13
## # Groups:   zip_code [1]
##   zip_code stu_pct_white pct_white stu_pct_black pct_black stu_pct_asian pct_asian stu_pct_latinx pct_latinx stu_pct_nhpi pct_nat_hi stu_pct_natam pct_nat_am
##   <chr>            <dbl>     <dbl>         <dbl>     <dbl>         <dbl>     <dbl>          <dbl>      <dbl>        <dbl>      <dbl>         <dbl>      <dbl>
## 1 77479            0.176     0.397        0.0252    0.0715         0.679     0.421         0.0825     0.0859            0          0       0.00210   0.000456

Zip code 94582

  • Filtered to the zip code 94582 to compare the racial/ethnic composition of students purchased in this zip code and the racial/ethnic composition of the population of this zip code
OOS_msa_94582_zip <- OOS_msa_top_5_zip %>%
  filter(zip_code == "94582") %>%
  dplyr::select(zip_code, stu_pct_white, pct_white, stu_pct_black, pct_black, stu_pct_asian, pct_asian, stu_pct_latinx, pct_latinx, stu_pct_nhpi, pct_nat_hi, stu_pct_natam, pct_nat_am) %>% head(n=1)

OOS_msa_94582_zip
## # A tibble: 1 x 13
## # Groups:   zip_code [1]
##   zip_code stu_pct_white pct_white stu_pct_black pct_black stu_pct_asian pct_asian stu_pct_latinx pct_latinx stu_pct_nhpi pct_nat_hi stu_pct_natam pct_nat_am
##   <chr>            <dbl>     <dbl>         <dbl>     <dbl>         <dbl>     <dbl>          <dbl>      <dbl>        <dbl>      <dbl>         <dbl>      <dbl>
## 1 94582           0.0774     0.304       0.00619    0.0258         0.811     0.554         0.0483     0.0590      0.00619    0.00457       0.00619   0.000865

Zip code 77382

  • Filtered to the zip code 77382 to compare the racial/ethnic composition of students purchased in this zip code and the racial/ethnic composition of the population of this zip code
OOS_msa_77382_zip <- OOS_msa_top_5_zip %>%
  filter(zip_code == "77382") %>%
  dplyr::select(zip_code, stu_pct_white, pct_white, stu_pct_black, pct_black, stu_pct_asian, pct_asian, stu_pct_latinx, pct_latinx, stu_pct_nhpi, pct_nat_hi, stu_pct_natam, pct_nat_am) %>% head(n=1)

OOS_msa_77382_zip
## # A tibble: 1 x 13
## # Groups:   zip_code [1]
##   zip_code stu_pct_white pct_white stu_pct_black pct_black stu_pct_asian pct_asian stu_pct_latinx pct_latinx stu_pct_nhpi pct_nat_hi stu_pct_natam pct_nat_am
##   <chr>            <dbl>     <dbl>         <dbl>     <dbl>         <dbl>     <dbl>          <dbl>      <dbl>        <dbl>      <dbl>         <dbl>      <dbl>
## 1 77382            0.544     0.721        0.0158    0.0187         0.196    0.0588          0.195      0.185      0.00316    0.00181             0          0

Zip code 30024

  • Filtered to the zip code 30024 to compare the racial/ethnic composition of students purchased in this zip code and the racial/ethnic composition of the population of this zip code
OOS_msa_30024_zip <- OOS_msa_top_5_zip %>%
  filter(zip_code == "30024") %>%
  dplyr::select(zip_code, stu_pct_white, pct_white, stu_pct_black, pct_black, stu_pct_asian, pct_asian, stu_pct_latinx, pct_latinx, stu_pct_nhpi, pct_nat_hi, stu_pct_natam, pct_nat_am) %>% head(n=1)

OOS_msa_30024_zip
## # A tibble: 1 x 13
## # Groups:   zip_code [1]
##   zip_code stu_pct_white pct_white stu_pct_black pct_black stu_pct_asian pct_asian stu_pct_latinx pct_latinx stu_pct_nhpi pct_nat_hi stu_pct_natam pct_nat_am
##   <chr>            <dbl>     <dbl>         <dbl>     <dbl>         <dbl>     <dbl>          <dbl>      <dbl>        <dbl>      <dbl>         <dbl>      <dbl>
## 1 30024            0.306     0.582        0.0432    0.0802         0.568     0.233         0.0493     0.0774            0          0       0.00719    0.00230

2.2 Non-ENG orders (6 orders)

OOS_noneng_orders
## # A tibble: 6 x 23
##   univ_id po_num   order_num order_title                   order_cost num_runs num_students date_start hs_grad_class  state_name                                                                                                                                  cbsa_name                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                segment                                                                                                                                                                                                                                                                                                                                             gender sat_score_min sat_score_max sat_score_old_min sat_score_old_max psat_score_min psat_score_max psat_score_old_min psat_score_old_max gpa_high gpa_low
##   <chr>   <chr>    <chr>     <chr>                              <dbl>    <dbl>        <dbl> <date>     <chr>          <chr>                                                                                                                                       <chr>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    <chr>                                                                                                                                                                                                                                                                                                                                               <chr>          <dbl>         <dbl>             <dbl>             <dbl>          <dbl>          <dbl>              <dbl>              <dbl> <chr>    <chr>  
## 1 145637  P1659111 483724    1240-1450 OOS ENG and NON ENG      1499.       NA         3332 2019-06-27 2021|2022      Armed Forces Americas (Except Canada)|Connecticut|Armed Forces Canada, Europe, Middle East, Africa|Missouri|California|Armed Forces Pacific IN - Indianapolis-Carmel-Anderson, IN|OH - Cincinnati, OH-KY-IN|MD - Baltimore-Columbia-Towson, MD|NC - Charlotte-Concord-Gastonia, NC-SC|FL - Orlando-Kissimmee-Sanford, FL|KS - Kansas City, MO-KS|GA - Atlanta-Sandy Springs-Roswell, GA|CO - Denver-Aurora-Lakewood, CO|CO - Boulder, CO|NJ - New York-Newark-Jersey City, NY-NJ-PA|MN - Minneapolis-St. Paul-Bloomington, MN-WI|VA - Washington-Arlington-Alexandria, DC-VA-MD-WV|TN - Nashville-Davidson--Murfreesboro--Franklin, TN|IA - Iowa City, IA|WI - Madison, WI|FL - Miami-Fort Lauderdale-West Palm Beach, FL|IN - Bloomington, IN|FL - Naples-Immokalee-Marco Island, FL|MI - Ann Arbor, MI|NJ - Philadelphia-Camden-Wilmington, PA-NJ-DE-MD|OH - Columbus, OH|MD - Washington-Arlington-Alexandria, DC-VA-MD-WV|OH - Cleveland-Elyria, OH|IN - Lafayette-West Lafayette, IN|MA - Boston-Cambridge-Newton, MA-NH|NY - New York-Newark-Jersey City, NY-NJ-PA|NC - Durham-Chapel Hill, NC|NC - Raleigh, NC|DC - Washington-Arlington-Alexandria, DC-VA-MD-WV|FL - Tampa-St. Petersburg-Clearwater, FL|MD - Philadelphia-Camden-Wilmington, PA-NJ-DE-MD|OH - Dayton, OH|WI - Milwaukee-Waukesha-West Allis, WI|PA - Philadelphia-Camden-Wilmington, PA-NJ-DE-MD|IA - Davenport-Moline-Rock Island, IA-IL|MI - Detroit-Warren-Dearborn, MI|GA - Athens-Clarke County, GA|WA - Seattle-Tacoma-Bellevue, WA|NJ - Trenton, NJ|AZ - Phoenix-Mesa-Scottsdale, AZ NA                                                                                                                                                                                                                                                                                                                                                  NA              1240          1450              1170              1400           1220           1450                115                140 A+       B-     
## 2 145637  P1659111 470283    OOS NON ENG March 2019              357.        3          794 2019-03-27 2021|2020|2022 Armed Forces Americas (Except Canada)|Connecticut|Armed Forces Canada, Europe, Middle East, Africa|Missouri|California|Armed Forces Pacific IN - Indianapolis-Carmel-Anderson, IN|OH - Cincinnati, OH-KY-IN|MD - Baltimore-Columbia-Towson, MD|NC - Charlotte-Concord-Gastonia, NC-SC|FL - Orlando-Kissimmee-Sanford, FL|KS - Kansas City, MO-KS|GA - Atlanta-Sandy Springs-Roswell, GA|CO - Denver-Aurora-Lakewood, CO|CO - Boulder, CO|NJ - New York-Newark-Jersey City, NY-NJ-PA|MN - Minneapolis-St. Paul-Bloomington, MN-WI|VA - Washington-Arlington-Alexandria, DC-VA-MD-WV|TN - Nashville-Davidson--Murfreesboro--Franklin, TN|IA - Iowa City, IA|WI - Madison, WI|FL - Miami-Fort Lauderdale-West Palm Beach, FL|IN - Bloomington, IN|FL - Naples-Immokalee-Marco Island, FL|MI - Ann Arbor, MI|NJ - Philadelphia-Camden-Wilmington, PA-NJ-DE-MD|OH - Columbus, OH|MD - Washington-Arlington-Alexandria, DC-VA-MD-WV|OH - Cleveland-Elyria, OH|IN - Lafayette-West Lafayette, IN|MA - Boston-Cambridge-Newton, MA-NH|NY - New York-Newark-Jersey City, NY-NJ-PA|NC - Durham-Chapel Hill, NC|NC - Raleigh, NC|DC - Washington-Arlington-Alexandria, DC-VA-MD-WV|FL - Tampa-St. Petersburg-Clearwater, FL|MD - Philadelphia-Camden-Wilmington, PA-NJ-DE-MD|OH - Dayton, OH|WI - Milwaukee-Waukesha-West Allis, WI|PA - Philadelphia-Camden-Wilmington, PA-NJ-DE-MD|IA - Davenport-Moline-Rock Island, IA-IL|MI - Detroit-Warren-Dearborn, MI|GA - Athens-Clarke County, GA|WA - Seattle-Tacoma-Bellevue, WA|NJ - Trenton, NJ|AZ - Phoenix-Mesa-Scottsdale, AZ EN:51, HS:68|EN:58, HS:70|EN:53, HS:70|EN:51, HS:65|EN:69, HS:70|EN:60, HS:68|EN:73, HS:70|EN:60, HS:65|EN:69, HS:68|EN:70, HS:68|EN:63, HS:70|EN:70, HS:66|EN:78, HS:ALL|EN:58, HS:65|EN:58, HS:64|EN:51, HS:79|EN:60, HS:70|EN:51, HS:70|EN:53, HS:65|EN:60, HS:79|EN:69, HS:75|EN:70, HS:70|EN:63, HS:65|EN:61, HS:ALL|EN:73, HS:65|EN:70, HS:79 NA              1240          1450              1170              1400           1240           1450                117                140 A+       B-     
## 3 145637  P1558959 371629    OOS Non-ENG - Feb 2018            12475.       NA        29012 2018-02-13 2019|2021|2020 Armed Forces Americas (Except Canada)|Connecticut|Armed Forces Canada, Europe, Middle East, Africa|Missouri|California|Armed Forces Pacific IN - Indianapolis-Carmel-Anderson, IN|OH - Cincinnati, OH-KY-IN|MD - Baltimore-Columbia-Towson, MD|NC - Charlotte-Concord-Gastonia, NC-SC|FL - Orlando-Kissimmee-Sanford, FL|KS - Kansas City, MO-KS|GA - Atlanta-Sandy Springs-Roswell, GA|CO - Denver-Aurora-Lakewood, CO|CO - Boulder, CO|NJ - New York-Newark-Jersey City, NY-NJ-PA|MN - Minneapolis-St. Paul-Bloomington, MN-WI|VA - Washington-Arlington-Alexandria, DC-VA-MD-WV|TN - Nashville-Davidson--Murfreesboro--Franklin, TN|IA - Iowa City, IA|WI - Madison, WI|FL - Miami-Fort Lauderdale-West Palm Beach, FL|IN - Bloomington, IN|FL - Naples-Immokalee-Marco Island, FL|MI - Ann Arbor, MI|NJ - Philadelphia-Camden-Wilmington, PA-NJ-DE-MD|OH - Columbus, OH|MD - Washington-Arlington-Alexandria, DC-VA-MD-WV|OH - Cleveland-Elyria, OH|IN - Lafayette-West Lafayette, IN|MA - Boston-Cambridge-Newton, MA-NH|NY - New York-Newark-Jersey City, NY-NJ-PA|NC - Durham-Chapel Hill, NC|NC - Raleigh, NC|DC - Washington-Arlington-Alexandria, DC-VA-MD-WV|FL - Tampa-St. Petersburg-Clearwater, FL|MD - Philadelphia-Camden-Wilmington, PA-NJ-DE-MD|OH - Dayton, OH|WI - Milwaukee-Waukesha-West Allis, WI|PA - Philadelphia-Camden-Wilmington, PA-NJ-DE-MD|IA - Davenport-Moline-Rock Island, IA-IL|MI - Detroit-Warren-Dearborn, MI|GA - Athens-Clarke County, GA|WA - Seattle-Tacoma-Bellevue, WA|NJ - Trenton, NJ|AZ - Phoenix-Mesa-Scottsdale, AZ EN:51, HS:68|EN:58, HS:70|EN:53, HS:70|EN:51, HS:65|EN:69, HS:70|EN:60, HS:68|EN:73, HS:70|EN:60, HS:65|EN:69, HS:68|EN:70, HS:68|EN:63, HS:70|EN:70, HS:66|EN:78, HS:ALL|EN:58, HS:65|EN:58, HS:64|EN:51, HS:79|EN:60, HS:70|EN:51, HS:70|EN:53, HS:65|EN:60, HS:79|EN:69, HS:75|EN:70, HS:70|EN:63, HS:65|EN:61, HS:ALL|EN:73, HS:65|EN:70, HS:79 NA              1240          1450              1170              1400           1240           1450                117                140 A+       B-     
## 4 145637  P1659111 456737    OOS Non-ENG - Feb 2019            10148.       NA        22552 2019-02-01 2021|2020|2022 Armed Forces Americas (Except Canada)|Connecticut|Armed Forces Canada, Europe, Middle East, Africa|Missouri|California|Armed Forces Pacific IN - Indianapolis-Carmel-Anderson, IN|OH - Cincinnati, OH-KY-IN|MD - Baltimore-Columbia-Towson, MD|NC - Charlotte-Concord-Gastonia, NC-SC|FL - Orlando-Kissimmee-Sanford, FL|KS - Kansas City, MO-KS|GA - Atlanta-Sandy Springs-Roswell, GA|CO - Denver-Aurora-Lakewood, CO|CO - Boulder, CO|NJ - New York-Newark-Jersey City, NY-NJ-PA|MN - Minneapolis-St. Paul-Bloomington, MN-WI|VA - Washington-Arlington-Alexandria, DC-VA-MD-WV|TN - Nashville-Davidson--Murfreesboro--Franklin, TN|IA - Iowa City, IA|WI - Madison, WI|FL - Miami-Fort Lauderdale-West Palm Beach, FL|IN - Bloomington, IN|FL - Naples-Immokalee-Marco Island, FL|MI - Ann Arbor, MI|NJ - Philadelphia-Camden-Wilmington, PA-NJ-DE-MD|OH - Columbus, OH|MD - Washington-Arlington-Alexandria, DC-VA-MD-WV|OH - Cleveland-Elyria, OH|IN - Lafayette-West Lafayette, IN|MA - Boston-Cambridge-Newton, MA-NH|NY - New York-Newark-Jersey City, NY-NJ-PA|NC - Durham-Chapel Hill, NC|NC - Raleigh, NC|DC - Washington-Arlington-Alexandria, DC-VA-MD-WV|FL - Tampa-St. Petersburg-Clearwater, FL|MD - Philadelphia-Camden-Wilmington, PA-NJ-DE-MD|OH - Dayton, OH|WI - Milwaukee-Waukesha-West Allis, WI|PA - Philadelphia-Camden-Wilmington, PA-NJ-DE-MD|IA - Davenport-Moline-Rock Island, IA-IL|MI - Detroit-Warren-Dearborn, MI|GA - Athens-Clarke County, GA|WA - Seattle-Tacoma-Bellevue, WA|NJ - Trenton, NJ|AZ - Phoenix-Mesa-Scottsdale, AZ EN:51, HS:68|EN:58, HS:70|EN:53, HS:70|EN:51, HS:65|EN:69, HS:70|EN:60, HS:68|EN:73, HS:70|EN:60, HS:65|EN:69, HS:68|EN:70, HS:68|EN:63, HS:70|EN:70, HS:66|EN:78, HS:ALL|EN:58, HS:65|EN:58, HS:64|EN:51, HS:79|EN:60, HS:70|EN:51, HS:70|EN:53, HS:65|EN:60, HS:79|EN:69, HS:75|EN:70, HS:70|EN:63, HS:65|EN:61, HS:ALL|EN:73, HS:65|EN:70, HS:79 NA              1240          1450              1170              1400           1240           1450                117                140 A+       B-     
## 5 145637  P1558959 386335    OOS Non-ENG - May 2018             5189.       NA        12067 2018-05-10 2019|2021|2020 Armed Forces Americas (Except Canada)|Connecticut|Armed Forces Canada, Europe, Middle East, Africa|Missouri|California|Armed Forces Pacific IN - Indianapolis-Carmel-Anderson, IN|OH - Cincinnati, OH-KY-IN|MD - Baltimore-Columbia-Towson, MD|NC - Charlotte-Concord-Gastonia, NC-SC|FL - Orlando-Kissimmee-Sanford, FL|KS - Kansas City, MO-KS|GA - Atlanta-Sandy Springs-Roswell, GA|CO - Denver-Aurora-Lakewood, CO|CO - Boulder, CO|NJ - New York-Newark-Jersey City, NY-NJ-PA|MN - Minneapolis-St. Paul-Bloomington, MN-WI|VA - Washington-Arlington-Alexandria, DC-VA-MD-WV|TN - Nashville-Davidson--Murfreesboro--Franklin, TN|IA - Iowa City, IA|WI - Madison, WI|FL - Miami-Fort Lauderdale-West Palm Beach, FL|IN - Bloomington, IN|FL - Naples-Immokalee-Marco Island, FL|MI - Ann Arbor, MI|NJ - Philadelphia-Camden-Wilmington, PA-NJ-DE-MD|OH - Columbus, OH|MD - Washington-Arlington-Alexandria, DC-VA-MD-WV|OH - Cleveland-Elyria, OH|IN - Lafayette-West Lafayette, IN|MA - Boston-Cambridge-Newton, MA-NH|NY - New York-Newark-Jersey City, NY-NJ-PA|NC - Durham-Chapel Hill, NC|NC - Raleigh, NC|DC - Washington-Arlington-Alexandria, DC-VA-MD-WV|FL - Tampa-St. Petersburg-Clearwater, FL|MD - Philadelphia-Camden-Wilmington, PA-NJ-DE-MD|OH - Dayton, OH|WI - Milwaukee-Waukesha-West Allis, WI|PA - Philadelphia-Camden-Wilmington, PA-NJ-DE-MD|IA - Davenport-Moline-Rock Island, IA-IL|MI - Detroit-Warren-Dearborn, MI|GA - Athens-Clarke County, GA|WA - Seattle-Tacoma-Bellevue, WA|NJ - Trenton, NJ|AZ - Phoenix-Mesa-Scottsdale, AZ EN:51, HS:68|EN:58, HS:70|EN:53, HS:70|EN:51, HS:65|EN:69, HS:70|EN:60, HS:68|EN:73, HS:70|EN:60, HS:65|EN:69, HS:68|EN:70, HS:68|EN:63, HS:70|EN:70, HS:66|EN:78, HS:ALL|EN:58, HS:65|EN:58, HS:64|EN:51, HS:79|EN:60, HS:70|EN:51, HS:70|EN:53, HS:65|EN:60, HS:79|EN:69, HS:75|EN:70, HS:70|EN:63, HS:65|EN:61, HS:ALL|EN:73, HS:65|EN:70, HS:79 NA              1240          1450              1170              1400           1240           1450                117                140 A+       B-     
## 6 145637  P1659111 403340    OOS Non-ENG August 2018             871.       NA         2026 2018-08-27 2021|2020      Armed Forces Americas (Except Canada)|Connecticut|Armed Forces Canada, Europe, Middle East, Africa|Missouri|California|Armed Forces Pacific IN - Indianapolis-Carmel-Anderson, IN|OH - Cincinnati, OH-KY-IN|MD - Baltimore-Columbia-Towson, MD|NC - Charlotte-Concord-Gastonia, NC-SC|FL - Orlando-Kissimmee-Sanford, FL|KS - Kansas City, MO-KS|GA - Atlanta-Sandy Springs-Roswell, GA|CO - Denver-Aurora-Lakewood, CO|CO - Boulder, CO|NJ - New York-Newark-Jersey City, NY-NJ-PA|MN - Minneapolis-St. Paul-Bloomington, MN-WI|VA - Washington-Arlington-Alexandria, DC-VA-MD-WV|TN - Nashville-Davidson--Murfreesboro--Franklin, TN|IA - Iowa City, IA|WI - Madison, WI|FL - Miami-Fort Lauderdale-West Palm Beach, FL|IN - Bloomington, IN|FL - Naples-Immokalee-Marco Island, FL|MI - Ann Arbor, MI|NJ - Philadelphia-Camden-Wilmington, PA-NJ-DE-MD|OH - Columbus, OH|MD - Washington-Arlington-Alexandria, DC-VA-MD-WV|OH - Cleveland-Elyria, OH|IN - Lafayette-West Lafayette, IN|MA - Boston-Cambridge-Newton, MA-NH|NY - New York-Newark-Jersey City, NY-NJ-PA|NC - Durham-Chapel Hill, NC|NC - Raleigh, NC|DC - Washington-Arlington-Alexandria, DC-VA-MD-WV|FL - Tampa-St. Petersburg-Clearwater, FL|MD - Philadelphia-Camden-Wilmington, PA-NJ-DE-MD|OH - Dayton, OH|WI - Milwaukee-Waukesha-West Allis, WI|PA - Philadelphia-Camden-Wilmington, PA-NJ-DE-MD|IA - Davenport-Moline-Rock Island, IA-IL|MI - Detroit-Warren-Dearborn, MI|GA - Athens-Clarke County, GA|WA - Seattle-Tacoma-Bellevue, WA|NJ - Trenton, NJ|AZ - Phoenix-Mesa-Scottsdale, AZ EN:51, HS:68|EN:58, HS:70|EN:53, HS:70|EN:51, HS:65|EN:69, HS:70|EN:60, HS:68|EN:73, HS:70|EN:60, HS:65|EN:69, HS:68|EN:70, HS:68|EN:63, HS:70|EN:70, HS:66|EN:78, HS:ALL|EN:58, HS:65|EN:58, HS:64|EN:51, HS:79|EN:60, HS:70|EN:51, HS:70|EN:53, HS:65|EN:60, HS:79|EN:69, HS:75|EN:70, HS:70|EN:63, HS:65|EN:61, HS:ALL|EN:73, HS:65|EN:70, HS:79 NA              1230          1450              1160              1400           1230           1450                116                140 A+       B-

They made 5 “OOS Non-ENG” orders & 1 “OOS ENG and Non-ENG” order between Feb 2018 & Jun 2019 w/ the criteria:

  • Specific MSAs + CA, CT, MO, and Armed Forces military districts
  • Above segment analysis filter for the 5 Non-ENG only orders but not the 1 order that included ENG majors too
  • A+ to B- high school GPA
  • SAT score of 1230/1240 - 1450 or PSAT score of 1220/1230/1240 - 1450
    • The 1 ENG & Non-ENG order had criteria of SAT 1240 - 1450 or PSAT 1220 - 1450

2.3 ENG orders (13 orders)

OOS_eng_orders
## # A tibble: 13 x 23
##    univ_id po_num   order_num order_title                   order_cost num_runs num_students date_start hs_grad_class       state_name                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          cbsa_name segment                                                                                                                                                                                                                                                                                                                                             gender           sat_score_min sat_score_max sat_score_old_min sat_score_old_max psat_score_min psat_score_max psat_score_old_min psat_score_old_max gpa_high gpa_low
##    <chr>   <chr>    <chr>     <chr>                              <dbl>    <dbl>        <dbl> <date>     <chr>               <chr>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               <chr>     <chr>                                                                                                                                                                                                                                                                                                                                               <chr>                    <dbl>         <dbl>             <dbl>             <dbl>          <dbl>          <dbl>              <dbl>              <dbl> <chr>    <chr>  
##  1 145637  P1659111 483701    OOS ENG 1400-1600                  220.        NA          489 2019-06-27 2021|2022           Vermont|Rhode Island|Hawaii|Maine|Virginia|Michigan|Idaho|Delaware|Iowa|Maryland|Massachusetts|Arkansas|Utah|Indiana|Minnesota|Arizona|Missouri|Montana|Mississippi|New Hampshire|New Jersey|New Mexico|Alaska|Texas|Alabama|North Carolina|North Dakota|Nebraska|New York|Georgia|Nevada|Tennessee|California|Oklahoma|Ohio|Wyoming|Florida|South Dakota|South Carolina|Connecticut|West Virginia|District of Columbia|Wisconsin|Kentucky|Kansas|Oregon|Louisiana|Washington|Colorado|Pennsylvania NA        EN:51, HS:68|EN:58, HS:70|EN:53, HS:70|EN:51, HS:65|EN:69, HS:70|EN:60, HS:68|EN:73, HS:70|EN:60, HS:65|EN:69, HS:68|EN:70, HS:68|EN:63, HS:70|EN:70, HS:66|EN:78, HS:ALL|EN:58, HS:65|EN:58, HS:64|EN:51, HS:79|EN:60, HS:70|EN:51, HS:70|EN:53, HS:65|EN:60, HS:79|EN:69, HS:75|EN:70, HS:70|EN:63, HS:65|EN:61, HS:ALL|EN:73, HS:65|EN:70, HS:79 No response|Male          1400          1600              1340              1600           1380           1520                132                149 A+       B-     
##  2 145637  P1659111 403333    OOS ENG Female - August 2018       108.        NA          252 2018-08-27 2021|2020           Vermont|Rhode Island|Hawaii|Maine|Virginia|Michigan|Idaho|Delaware|Iowa|Maryland|Massachusetts|Arkansas|Utah|Indiana|Minnesota|Arizona|Missouri|Montana|Mississippi|New Hampshire|New Jersey|New Mexico|Alaska|Texas|Alabama|North Carolina|North Dakota|Nebraska|New York|Georgia|Nevada|Tennessee|California|Oklahoma|Ohio|Wyoming|Florida|South Dakota|South Carolina|Connecticut|West Virginia|District of Columbia|Wisconsin|Kentucky|Kansas|Oregon|Louisiana|Washington|Colorado|Pennsylvania NA        EN:51, HS:68|EN:58, HS:70|EN:53, HS:70|EN:51, HS:65|EN:69, HS:70|EN:60, HS:68|EN:73, HS:70|EN:60, HS:65|EN:69, HS:68|EN:70, HS:68|EN:63, HS:70|EN:70, HS:66|EN:78, HS:ALL|EN:58, HS:65|EN:58, HS:64|EN:51, HS:79|EN:60, HS:70|EN:51, HS:70|EN:53, HS:65|EN:60, HS:79|EN:69, HS:75|EN:70, HS:70|EN:63, HS:65|EN:61, HS:ALL|EN:73, HS:65|EN:70, HS:79 Female                    1300          1600              1230              1600           1300           1520                123                149 A+       B-     
##  3 145637  P1558959 371665    OOS ENG Female - Feb 2018         1479.        NA         3439 2018-02-13 2019|2021|2020      Vermont|Rhode Island|Hawaii|Maine|Virginia|Michigan|Idaho|Delaware|Iowa|Maryland|Massachusetts|Arkansas|Utah|Indiana|Minnesota|Arizona|Missouri|Montana|Mississippi|New Hampshire|New Jersey|New Mexico|Alaska|Texas|Alabama|North Carolina|North Dakota|Nebraska|New York|Georgia|Nevada|Tennessee|California|Oklahoma|Ohio|Wyoming|Florida|South Dakota|South Carolina|Connecticut|West Virginia|District of Columbia|Wisconsin|Kentucky|Kansas|Oregon|Louisiana|Washington|Colorado|Pennsylvania NA        EN:51, HS:68|EN:58, HS:70|EN:53, HS:70|EN:51, HS:65|EN:69, HS:70|EN:60, HS:68|EN:73, HS:70|EN:60, HS:65|EN:69, HS:68|EN:70, HS:68|EN:63, HS:70|EN:70, HS:66|EN:78, HS:ALL|EN:58, HS:65|EN:58, HS:64|EN:51, HS:79|EN:60, HS:70|EN:51, HS:70|EN:53, HS:65|EN:60, HS:79|EN:69, HS:75|EN:70, HS:70|EN:63, HS:65|EN:61, HS:ALL|EN:73, HS:65|EN:70, HS:79 Female                    1310          1600              1250              1600           1310           1520                125                149 A+       B-     
##  4 145637  P1558959 386336    OOS ENG Female - May 2018          526.        NA         1224 2018-05-10 2019|2021|2020      Vermont|Rhode Island|Hawaii|Maine|Virginia|Michigan|Idaho|Delaware|Iowa|Maryland|Massachusetts|Arkansas|Utah|Indiana|Minnesota|Arizona|Missouri|Montana|Mississippi|New Hampshire|New Jersey|New Mexico|Alaska|Texas|Alabama|North Carolina|North Dakota|Nebraska|New York|Georgia|Nevada|Tennessee|California|Oklahoma|Ohio|Wyoming|Florida|South Dakota|South Carolina|Connecticut|West Virginia|District of Columbia|Wisconsin|Kentucky|Kansas|Oregon|Louisiana|Washington|Colorado|Pennsylvania NA        EN:51, HS:68|EN:58, HS:70|EN:53, HS:70|EN:51, HS:65|EN:69, HS:70|EN:60, HS:68|EN:73, HS:70|EN:60, HS:65|EN:69, HS:68|EN:70, HS:68|EN:63, HS:70|EN:70, HS:66|EN:78, HS:ALL|EN:58, HS:65|EN:58, HS:64|EN:51, HS:79|EN:60, HS:70|EN:51, HS:70|EN:53, HS:65|EN:60, HS:79|EN:69, HS:75|EN:70, HS:70|EN:63, HS:65|EN:61, HS:ALL|EN:73, HS:65|EN:70, HS:79 Female                    1310          1600              1250              1600           1310           1520                125                149 A+       B-     
##  5 145637  P1659111 469731    OOS ENG Male - APRIL 2019           54.9       NA          122 2019-03-22 2021|2020|2022      Vermont|Rhode Island|Hawaii|Maine|Virginia|Michigan|Idaho|Delaware|Iowa|Maryland|Massachusetts|Arkansas|Utah|Indiana|Minnesota|Arizona|Missouri|Montana|Mississippi|New Hampshire|New Jersey|New Mexico|Alaska|Texas|Alabama|North Carolina|North Dakota|Nebraska|New York|Georgia|Nevada|Tennessee|California|Oklahoma|Ohio|Wyoming|Florida|South Dakota|South Carolina|Connecticut|West Virginia|District of Columbia|Wisconsin|Kentucky|Kansas|Oregon|Louisiana|Washington|Colorado|Pennsylvania NA        EN:51, HS:68|EN:58, HS:70|EN:53, HS:70|EN:51, HS:65|EN:69, HS:70|EN:60, HS:68|EN:73, HS:70|EN:60, HS:65|EN:69, HS:68|EN:70, HS:68|EN:63, HS:70|EN:70, HS:66|EN:78, HS:ALL|EN:58, HS:65|EN:58, HS:64|EN:51, HS:79|EN:60, HS:70|EN:51, HS:70|EN:53, HS:65|EN:60, HS:79|EN:69, HS:75|EN:70, HS:70|EN:63, HS:65|EN:61, HS:ALL|EN:73, HS:65|EN:70, HS:79 No response|Male          1420          1600              1370              1600           1420           1520                137                149 A+       B-     
##  6 145637  P1659111 403314    OOS ENG Male - August 2018         122.        NA          284 2018-08-27 2021|2020           Vermont|Rhode Island|Hawaii|Maine|Virginia|Michigan|Idaho|Delaware|Iowa|Maryland|Massachusetts|Arkansas|Utah|Indiana|Minnesota|Arizona|Missouri|Montana|Mississippi|New Hampshire|New Jersey|New Mexico|Alaska|Texas|Alabama|North Carolina|North Dakota|Nebraska|New York|Georgia|Nevada|Tennessee|California|Oklahoma|Ohio|Wyoming|Florida|South Dakota|South Carolina|Connecticut|West Virginia|District of Columbia|Wisconsin|Kentucky|Kansas|Oregon|Louisiana|Washington|Colorado|Pennsylvania NA        EN:51, HS:68|EN:58, HS:70|EN:53, HS:70|EN:51, HS:65|EN:69, HS:70|EN:60, HS:68|EN:73, HS:70|EN:60, HS:65|EN:69, HS:68|EN:70, HS:68|EN:63, HS:70|EN:70, HS:66|EN:78, HS:ALL|EN:58, HS:65|EN:58, HS:64|EN:51, HS:79|EN:60, HS:70|EN:51, HS:70|EN:53, HS:65|EN:60, HS:79|EN:69, HS:75|EN:70, HS:70|EN:63, HS:65|EN:61, HS:ALL|EN:73, HS:65|EN:70, HS:79 No response|Male          1420          1600              1370              1600           1420           1520                137                149 A+       B-     
##  7 145637  P1558959 371662    OOS ENG Male - Feb 2018           2272.        NA         5283 2018-02-13 2019|2021|2020      Vermont|Rhode Island|Hawaii|Maine|Virginia|Michigan|Idaho|Delaware|Iowa|Maryland|Massachusetts|Arkansas|Utah|Indiana|Minnesota|Arizona|Missouri|Montana|Mississippi|New Hampshire|New Jersey|New Mexico|Alaska|Texas|Alabama|North Carolina|North Dakota|Nebraska|New York|Georgia|Nevada|Tennessee|California|Oklahoma|Ohio|Wyoming|Florida|South Dakota|South Carolina|Connecticut|West Virginia|District of Columbia|Wisconsin|Kentucky|Kansas|Oregon|Louisiana|Washington|Colorado|Pennsylvania NA        EN:51, HS:68|EN:58, HS:70|EN:53, HS:70|EN:51, HS:65|EN:69, HS:70|EN:60, HS:68|EN:73, HS:70|EN:60, HS:65|EN:69, HS:68|EN:70, HS:68|EN:63, HS:70|EN:70, HS:66|EN:78, HS:ALL|EN:58, HS:65|EN:58, HS:64|EN:51, HS:79|EN:60, HS:70|EN:51, HS:70|EN:53, HS:65|EN:60, HS:79|EN:69, HS:75|EN:70, HS:70|EN:63, HS:65|EN:61, HS:ALL|EN:73, HS:65|EN:70, HS:79 No response|Male          1420          1600              1370              1600           1420           1520                137                149 A+       B-     
##  8 145637  P1659111 456710    OOS ENG Male - Feb 2019           2048.        NA         4551 2019-02-01 2021|2020|2022      Vermont|Rhode Island|Hawaii|Maine|Virginia|Michigan|Idaho|Delaware|Iowa|Maryland|Massachusetts|Arkansas|Utah|Indiana|Minnesota|Arizona|Missouri|Montana|Mississippi|New Hampshire|New Jersey|New Mexico|Alaska|Texas|Alabama|North Carolina|North Dakota|Nebraska|New York|Georgia|Nevada|Tennessee|California|Oklahoma|Ohio|Wyoming|Florida|South Dakota|South Carolina|Connecticut|West Virginia|District of Columbia|Wisconsin|Kentucky|Kansas|Oregon|Louisiana|Washington|Colorado|Pennsylvania NA        EN:51, HS:68|EN:58, HS:70|EN:53, HS:70|EN:51, HS:65|EN:69, HS:70|EN:60, HS:68|EN:73, HS:70|EN:60, HS:65|EN:69, HS:68|EN:70, HS:68|EN:63, HS:70|EN:70, HS:66|EN:78, HS:ALL|EN:58, HS:65|EN:58, HS:64|EN:51, HS:79|EN:60, HS:70|EN:51, HS:70|EN:53, HS:65|EN:60, HS:79|EN:69, HS:75|EN:70, HS:70|EN:63, HS:65|EN:61, HS:ALL|EN:73, HS:65|EN:70, HS:79 No response|Male          1420          1600              1370              1600           1420           1520                137                149 A+       B-     
##  9 145637  P1558959 386441    OOS ENG Male - May 2018            986.        NA         2292 2018-05-10 2019|2021|2020      Vermont|Rhode Island|Hawaii|Maine|Virginia|Michigan|Idaho|Delaware|Iowa|Maryland|Massachusetts|Arkansas|Utah|Indiana|Minnesota|Arizona|Missouri|Montana|Mississippi|New Hampshire|New Jersey|New Mexico|Alaska|Texas|Alabama|North Carolina|North Dakota|Nebraska|New York|Georgia|Nevada|Tennessee|California|Oklahoma|Ohio|Wyoming|Florida|South Dakota|South Carolina|Connecticut|West Virginia|District of Columbia|Wisconsin|Kentucky|Kansas|Oregon|Louisiana|Washington|Colorado|Pennsylvania NA        EN:51, HS:68|EN:58, HS:70|EN:53, HS:70|EN:51, HS:65|EN:69, HS:70|EN:60, HS:68|EN:73, HS:70|EN:60, HS:65|EN:69, HS:68|EN:70, HS:68|EN:63, HS:70|EN:70, HS:66|EN:78, HS:ALL|EN:58, HS:65|EN:58, HS:64|EN:51, HS:79|EN:60, HS:70|EN:51, HS:70|EN:53, HS:65|EN:60, HS:79|EN:69, HS:75|EN:70, HS:70|EN:63, HS:65|EN:61, HS:ALL|EN:73, HS:65|EN:70, HS:79 No response|Male          1420          1600              1370              1600           1420           1520                137                149 A+       B-     
## 10 145637  P1659111 470123    OOS ENG-Female New March 2019     1510.         4         3356 2019-03-27 2021|2020|2022      Vermont|Rhode Island|Hawaii|Maine|Virginia|Michigan|Idaho|Delaware|Iowa|Maryland|Massachusetts|Arkansas|Utah|Indiana|Minnesota|Arizona|Missouri|Montana|Mississippi|New Hampshire|New Jersey|New Mexico|Alaska|Texas|Alabama|North Carolina|North Dakota|Nebraska|New York|Georgia|Nevada|Tennessee|California|Oklahoma|Ohio|Wyoming|Florida|South Dakota|South Carolina|Connecticut|West Virginia|District of Columbia|Wisconsin|Kentucky|Kansas|Oregon|Louisiana|Washington|Colorado|Pennsylvania NA        EN:51, HS:68|EN:58, HS:70|EN:53, HS:70|EN:51, HS:65|EN:69, HS:70|EN:60, HS:68|EN:73, HS:70|EN:60, HS:65|EN:69, HS:68|EN:70, HS:68|EN:63, HS:70|EN:70, HS:66|EN:78, HS:ALL|EN:58, HS:65|EN:58, HS:64|EN:51, HS:79|EN:60, HS:70|EN:51, HS:70|EN:53, HS:65|EN:60, HS:79|EN:69, HS:75|EN:70, HS:70|EN:63, HS:65|EN:61, HS:ALL|EN:73, HS:65|EN:70, HS:79 Female                    1350          1600              1290              1600           1330           1520                127                149 A+       B-     
## 11 145637  P1659111 483702    OOS Female ENG                      47.7       NA          106 2019-06-27 2021|2022           Vermont|Rhode Island|Hawaii|Maine|Virginia|Michigan|Idaho|Delaware|Iowa|Maryland|Massachusetts|Arkansas|Utah|Indiana|Minnesota|Arizona|Missouri|Montana|Mississippi|New Hampshire|New Jersey|New Mexico|Alaska|Texas|Alabama|North Carolina|North Dakota|Nebraska|New York|Georgia|Nevada|Tennessee|California|Oklahoma|Ohio|Wyoming|Florida|South Dakota|South Carolina|Connecticut|West Virginia|District of Columbia|Wisconsin|Kentucky|Kansas|Oregon|Louisiana|Washington|Colorado|Pennsylvania NA        EN:51, HS:68|EN:58, HS:70|EN:53, HS:70|EN:51, HS:65|EN:69, HS:70|EN:60, HS:68|EN:73, HS:70|EN:60, HS:65|EN:69, HS:68|EN:70, HS:68|EN:63, HS:70|EN:70, HS:66|EN:78, HS:ALL|EN:58, HS:65|EN:58, HS:64|EN:51, HS:79|EN:60, HS:70|EN:51, HS:70|EN:53, HS:65|EN:60, HS:79|EN:69, HS:75|EN:70, HS:70|EN:63, HS:65|EN:61, HS:ALL|EN:73, HS:65|EN:70, HS:79 Female                    1300          1600              1230              1600           1300           1520                123                149 A+       B-     
## 12 145637  P1887010 500494    OOS Female ENG 2020                505.         4         1074 2019-09-04 2021|2020|2023|2022 Vermont|Rhode Island|Hawaii|Maine|Virginia|Michigan|Idaho|Delaware|Iowa|Maryland|Massachusetts|Arkansas|Utah|Indiana|Minnesota|Arizona|Missouri|Montana|Mississippi|New Hampshire|New Jersey|New Mexico|Alaska|Texas|Alabama|North Carolina|North Dakota|Nebraska|New York|Georgia|Nevada|Tennessee|California|Oklahoma|Ohio|Wyoming|Florida|South Dakota|South Carolina|Connecticut|West Virginia|District of Columbia|Wisconsin|Kentucky|Kansas|Oregon|Louisiana|Washington|Colorado|Pennsylvania NA        EN:51, HS:68|EN:58, HS:70|EN:53, HS:70|EN:51, HS:65|EN:69, HS:70|EN:60, HS:68|EN:73, HS:70|EN:60, HS:65|EN:69, HS:68|EN:70, HS:68|EN:63, HS:70|EN:70, HS:66|EN:78, HS:ALL|EN:58, HS:65|EN:58, HS:64|EN:51, HS:79|EN:60, HS:70|EN:51, HS:70|EN:53, HS:65|EN:60, HS:79|EN:69, HS:75|EN:70, HS:70|EN:63, HS:65|EN:61, HS:ALL|EN:73, HS:65|EN:70, HS:79 Female                    1350          1600              1290              1600           1330           1520                127                149 A+       B-     
## 13 145637  P1659111 567377    OOS Female ENG 2021                774.        NA         1646 2020-04-03 2021|2023|2022      Vermont|Rhode Island|Hawaii|Maine|Virginia|Michigan|Idaho|Delaware|Iowa|Maryland|Massachusetts|Arkansas|Utah|Indiana|Minnesota|Arizona|Missouri|Montana|Mississippi|New Hampshire|New Jersey|New Mexico|Alaska|Texas|Alabama|North Carolina|North Dakota|Nebraska|New York|Georgia|Nevada|Tennessee|California|Oklahoma|Ohio|Wyoming|Florida|South Dakota|South Carolina|Connecticut|West Virginia|District of Columbia|Wisconsin|Kentucky|Kansas|Oregon|Louisiana|Washington|Colorado|Pennsylvania NA        EN:51, HS:68|EN:58, HS:70|EN:53, HS:70|EN:51, HS:65|EN:69, HS:70|EN:60, HS:68|EN:73, HS:70|EN:60, HS:65|EN:69, HS:68|EN:70, HS:68|EN:63, HS:70|EN:70, HS:66|EN:78, HS:ALL|EN:58, HS:65|EN:58, HS:64|EN:51, HS:79|EN:60, HS:70|EN:51, HS:70|EN:53, HS:65|EN:60, HS:79|EN:69, HS:75|EN:70, HS:70|EN:63, HS:65|EN:61, HS:ALL|EN:73, HS:65|EN:70, HS:79 Female                    1350          1600              1290              1600           1330           1520                127                149 A+       B-
# Lower test score criteria for female students
OOS_eng_orders %>% dplyr::select(gender, sat_score_min, sat_score_max, psat_score_min, psat_score_max) %>%
  distinct() %>% arrange(sat_score_min)
## # A tibble: 5 x 5
##   gender           sat_score_min sat_score_max psat_score_min psat_score_max
##   <chr>                    <dbl>         <dbl>          <dbl>          <dbl>
## 1 Female                    1300          1600           1300           1520
## 2 Female                    1310          1600           1310           1520
## 3 Female                    1350          1600           1330           1520
## 4 No response|Male          1400          1600           1380           1520
## 5 No response|Male          1420          1600           1420           1520
# Fewer female students purchased
OOS_eng_orders %>% group_by(gender) %>%
  summarise(num_orders = n(), total_cost = sum(order_cost), total_students = sum(num_students))
## # A tibble: 2 x 4
##   gender           num_orders total_cost total_students
##   <chr>                 <int>      <dbl>          <dbl>
## 1 Female                    7      4950.          11097
## 2 No response|Male          6      5702.          13021

They made 6 “OOS ENG Male” orders & 7 “OOS ENG Female” orders between Feb 2018 & Apr 2020 w/ the criteria:

  • All 49 states except IL + DC
  • Above segment analysis filter
  • A+ to B- high school GPA
  • SAT/PSAT score filter which differs by gender

General observations:

  • More purchases made for female students and w/ lower test score criteria, but resulting female engineering majors in list still less than total male students

3 International purchases (4 orders)

intl_orders
## # A tibble: 4 x 20
##   univ_id po_num   order_num order_title                          order_cost num_runs num_students date_start hs_grad_class  intl_region                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    sat_score_min sat_score_max sat_score_old_min sat_score_old_max psat_score_min psat_score_max psat_score_old_min psat_score_old_max gpa_high gpa_low
##   <chr>   <chr>    <chr>     <chr>                                     <dbl>    <dbl>        <dbl> <date>     <chr>          <chr>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  <dbl>         <dbl>             <dbl>             <dbl>          <dbl>          <dbl>              <dbl>              <dbl> <chr>    <chr>  
## 1 145637  P1659111 483721    1150-1500 INTL Travel Countries Only       396.       NA          879 2019-06-27 2021|2022      AS-3 - Egypt|AC-7 - Hong Kong|AS-4 - India|AC-8 - Indonesia|AS-7 - Jordan|AC-16 - Korea, South (ROK)|AC-29 - Macao|AC-10 - Malaysia|AS-14 - Saudi Arabia|AS-17 - United Arab Emirates|AC-20 - Viet Nam                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  1200          1500              1130              1460           1150           1450                108                140 A+       B-     
## 2 145637  P1558959 372044    China Search - Feb 2018                    986.       NA         2293 2018-05-10 2019|2021|2020 AC-5 - China                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            1350          1600              1290              1600           1350           1520                129                149 A+       B-     
## 3 145637  P1659111 470250    International Non China Search March      1384.        4         3076 2019-03-27 2021|2020|2022 EW-26 - Aaland Islands|AS-19 - Afghanistan|EC-13 - Albania|CA01 - Alberta|CA01 - Alberta|AF-28 - Algeria|EW-27 - Andorra|AF-29 - Angola|CR-12 - Anguilla|CR-13 - Antigua and Barbuda|SA-2 - Argentina|AS-20 - Armenia|CR-14 - Aruba|AC-1 - Australia|EW-1 - Austria|AS-21 - Azerbaijan|CR-1 - Bahamas|AS-1 - Bahrain|AS-2 - Bangladesh|CR-15 - Barbados|EC-14 - Belarus|EW-2 - Belgium|MM-2 - Belize|AF-30 - Benin|CR-2 - Bermuda|AC-22 - Bhutan|SA-3 - Bolivia|CR-24 - Bonaire, Sint Eustasius, and Saba|EC-15 - Bosnia and Herzegovina|AF-2 - Botswana|SA-15 - Bouvet Island|SA-4 - Brazil|CA02 - British Columbia|CA02 - British Columbia|AF-55 - British Indian Ocean Territory|AC-2 - Brunei Darussalam|EC-1 - Bulgaria|AF-3 - Burkina Faso|AF-31 - Burundi|AC-4 - Cambodia|AF-4 - Cameroon|AF-32 - Cape Verde|CR-3 - Cayman Islands|AF-33 - Central African Republic|AF-34 - Chad|SA-5 - Chile|AC-39 - Christmas Island|AC-40 - Cocos (Keeling) Islands|SA-6 - Colombia|AF-35 - Comoros|AF-36 - Congo|AF-5 - Congo, The Democratic Republic Of The|AC-23 - Cook Islands|MM-3 - Costa Rica|AF-9 - Cote D'Ivoire|EC-16 - Croatia|CR-4 - Cuba|CR-25 - Curacao|EW-3 - Cyprus|EC-2 - Czechia|EW-4 - Denmark|AF-37 - Djibouti|CR-17 - Dominica|CR-5 - Dominican Republic|SA-7 - Ecuador|AS-3 - Egypt|MM-4 - El Salvador|AF-38 - Equatorial Guinea|AF-39 - Eritrea|EC-17 - Estonia|AF-6 - Ethiopia|AF-56 - Falkland Islands (Malvinas)|EW-28 - Faroe Islands|AC-6 - Fiji|EW-6 - Finland|EW-7 - France|SA-14 - French Guiana|AC-24 - French Polynesia|AF-57 - French Southern Territories|AF-40 - Gabon|AF-7 - Gambia|AS-22 - Georgia|EW-8 - Germany|AF-8 - Ghana|EW-29 - Gibraltar|EW-9 - Greece|EW-30 - Greenland|CR-6 - Grenada|AC-25 - Guadeloupe|MM-5 - Guatemala|EW-36 - Guernsey|AF-41 - Guinea|AF-42 - Guinea-Bissau|SA-8 - Guyana|CR-7 - Haiti|AC-41 - Heard Island and Mcdonald Islands|EW-31 - Holy See (Vatican City State)|MM-6 - Honduras|AC-7 - Hong Kong|EC-3 - Hungary|EW-10 - Iceland|AS-4 - India|AC-8 - Indonesia|AS-23 - Iran, Islamic Republic Of|AS-5 - Iraq|EW-11 - Ireland|EW-35 - Isle Of Man|AS-6 - Israel|EW-12 - Italy|CR-8 - Jamaica|AC-9 - Japan|EW-37 - Jersey|AS-7 - Jordan|AS-24 - Kazakhstan|AF-10 - Kenya|AC-26 - Kiribati|AC-27 - Korea, North (DPR)|AC-16 - Korea, South (ROK)|EC-23 - Kosovo|AS-8 - Kuwait|AS-25 - Kyrgyzstan|AC-28 - Lao People's Democratic Republic|EC-5 - Latvia|AS-9 - Lebanon|AF-11 - Lesotho|AF-43 - Liberia|AF-44 - Libya|EW-32 - Liechtenstein|EC-18 - Lithuania|EW-13 - Luxembourg|AC-29 - Macao|EC-6 - Macedonia, The Former Yugoslav Republic Of|AF-12 - Madagascar|AF-13 - Malawi|AC-10 - Malaysia|AS-26 - Maldives|AF-45 - Mali|EW-14 - Malta|CA03 - Manitoba|CA03 - Manitoba|CR-18 - Martinique|AF-46 - Mauritania|AF-14 - Mauritius|AF-58 - Mayotte|MM-7 - Mexico|EC-19 - Moldova, Republic Of|EW-33 - Monaco|AC-31 - Mongolia|EC-20 - Montenegro|CR-19 - Montserrat|AF-15 - Morocco|AF-16 - Mozambique|AC-3 - Myanmar|AF-47 - Namibia|AC-32 - Nauru|AS-10 - Nepal|EW-15 - Netherlands|CR-9 - Netherlands Antilles|CA04 - New Brunswick|CA04 - New Brunswick|AC-33 - New Caledonia|AC-11 - New Zealand|CA05 - Newfoundland and Labrador|CA05 - Newfoundland and Labrador|MM-8 - Nicaragua|AF-48 - Niger|AF-17 - Nigeria|AC-34 - Niue|AC-42 - Norfolk Island|CA06 - Northwest Territories|CA06 - Northwest Territories|EW-17 - Norway|CA07 - Nova Scotia|CA07 - Nova Scotia|CA13 - Nunavut|CA13 - Nunavut|AS-11 - Oman|CA08 - Ontario|CA08 - Ontario|AS-12 - Pakistan|AC-12 - Palau|AS-27 - Palestine, State of|MM-9 - Panama|AC-13 - Papua New Guinea|SA-9 - Paraguay|SA-10 - Peru|AC-14 - Philippines|AF-59 - Pitcairn|EW-18 - Poland|EW-19 - Portugal|CA09 - Prince Edward Island|CA09 - Prince Edward Island|AS-13 - Qatar|CA10 - Quebec|CA10 - Quebec|AF-49 - Reunion|EC-7 - Romania|EC-8 - Russian Federation|AF-50 - Rwanda|CR-26 - Saint Barthelemy|AF-60 - Saint Helena, Ascension and Tristan da Cunha|CR-22 - Saint Kitts and Nevis|CR-20 - Saint Lucia|CR-27 - Saint Martin (French Part)|EW-38 - Saint Pierre and Miquelon|CR-21 - Saint Vincent and The Grenadines|AC-21 - Samoa|EW-34 - San Marino|AF-51 - Sao Tome and Principe|CA11 - Saskatchewan|CA11 - Saskatchewan|AS-14 - Saudi Arabia|AF-18 - Senegal|EC-21 - Serbia|AF-52 - Seychelles|AF-19 - Sierra Leone|AC-15 - Singapore|CR-28 - Sint Maarten (Dutch Part)|EC-9 - Slovakia|EC-10 - Slovenia|AC-36 - Solomon Islands|AF-53 - Somalia|AF-20 - South Africa|SA-16 - South Georgia and The South Sandwich Islands|AF-62 - South Sudan|EW-21 - Spain|AS-15 - Sri Lanka|AF-21 - Sudan|SA-11 - Suriname|EW-39 - Svalbard and Jan Mayen|AF-22 - Swaziland|EW-22 - Sweden|EW-23 - Switzerland|AS-16 - Syrian Arab Republic|AC-17 - Taiwan|AS-28 - Tajikistan|AF-23 - Tanzania, United Republic Of|AC-18 - Thailand|AC-43 - Timor-Leste|AF-54 - Togo|AC-44 - Tokelau|AC-19 - Tonga|CR-10 - Trinidad and Tobago|AF-24 - Tunisia|EC-22 - Turkey|AS-29 - Turkmenistan|CR-23 - Turks and Caicos Islands|AC-37 - Tuvalu|AF-25 - Uganda|EC-11 - Ukraine|AS-17 - United Arab Emirates|EW-5 - United Kingdom|SA-12 - Uruguay|AS-30 - Uzbekistan|AC-38 - Vanuatu|SA-13 - Venezuela|AC-20 - Viet Nam|CR-16 - Virgin Islands, British|AC-45 - Wallis and Futuna|AF-61 - Western Sahara|AS-18 - Yemen|CA12 - Yukon Territory|CA12 - Yukon Territory|AF-26 - Zambia|AF-27 - Zimbabwe          1240          1450              1170              1400           1240           1450                117                140 A+       B-     
## 4 145637  P1558959 371669    Intl Broad Search - Feb 2018              4535.       NA        10546 2018-05-10 2019|2021|2020 AC-7 - Hong Kong|AS-4 - India|AC-8 - Indonesia|AC-9 - Japan|AC-16 - Korea, South (ROK)|AF-17 - Nigeria|AS-12 - Pakistan|AS-13 - Qatar|AS-14 - Saudi Arabia|AC-15 - Singapore|AC-17 - Taiwan|AC-18 - Thailand|EC-22 - Turkey|AS-17 - United Arab Emirates                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                1240          1600              1170              1600           1240           1520                117                149 A+       B-

They made 4 international orders between May 2018 & June 2019 with the following search criteria:

  • All filter for A+/B- high school GPA
  • SAT/PSAT scores vary by country.
intl_orders %>% dplyr::select(order_title, order_num, num_students, sat_score_min, sat_score_max, psat_score_min, psat_score_max)
## # A tibble: 4 x 7
##   order_title                          order_num num_students sat_score_min sat_score_max psat_score_min psat_score_max
##   <chr>                                <chr>            <dbl>         <dbl>         <dbl>          <dbl>          <dbl>
## 1 1150-1500 INTL Travel Countries Only 483721             879          1200          1500           1150           1450
## 2 China Search - Feb 2018              372044            2293          1350          1600           1350           1520
## 3 International Non China Search March 470250            3076          1240          1450           1240           1450
## 4 Intl Broad Search - Feb 2018         371669           10546          1240          1600           1240           1520

4 CA HS SAT EDA

la_zip_codes <- (zip_cbsa_data %>% filter(cbsa_1 == '31080'))$zip_code

# Look at just College Board LA students
lists_df_sat_la <- lists_df_sat %>%
  select(-test_type, -order_num, -order_date) %>% distinct() %>%  # Each student is unique - got rid of duplicates that came from multiple orders
  mutate(
    zip_code = str_pad(str_sub(ZipCode, 1, 5), width = 5, pad = '0', side = 'left'),
    ceeb = str_pad(SchoolCode, width = 6, pad = '0', side = 'left'),
    is_white = as.integer(str_detect(Race, 'White')),
  ) %>% 
  filter(zip_code %in% la_zip_codes)
length(unique(lists_df_sat_la$zip_code))  # 307 zip codes in LA
## [1] 307
length(unique(lists_df_sat_la$ceeb))  # 348 HS in LA
## [1] 348
# Group by HS
lists_df_sat_la_hs <- lists_df_sat_la %>%
  group_by(ceeb) %>% 
  summarise(total_students_purchased = n(), pct_white_purchased = mean(is_white, na.rm = T) * 100) %>% 
  arrange(-total_students_purchased) %>%
  left_join(ceeb_nces, by = 'ceeb') %>% 
  left_join(cds_nces %>% select(ncessch, CDSCode), by = 'ncessch') %>% 
  left_join(hs_data %>% select(ncessch, total_students, pct_white), by = 'ncessch') %>% 
  left_join(df_sat_ca_20, by = c('CDSCode' = 'CDS'))

lists_df_sat_la_hs
## # A tibble: 360 x 39
##    ceeb   total_students_purchased pct_white_purchased ncessch      CDSCode        total_students pct_white CCode CDCode  SCode   RType SName                       DName                          CName       Enroll12 NumTSTTakr12 NumERWBenchmark12 PctERWBenchmark12 NumMathBenchmark12 PctMathBenchmark12 Enroll11 NumTSTTakr11 NumERWBenchmark11 PctERWBenchmark11 NumMathBenchmark11 PctMathBenchmark11 TotNumBothBenchmark12 PctBothBenchmark12 TotNumBothBenchmark11 PctBothBenchmark11 Year    Enroll1112 NumTSTTakr1112 NumERWBenchmark1112 PctERWBenchmark1112 NumMathBenchmark1112 PctMathBenchmark1112 TotNumBothBenchmark1112 PctBothBenchmark1112
##    <chr>                     <int>               <dbl> <chr>        <chr>                   <dbl>     <dbl> <chr> <chr>   <chr>   <chr> <chr>                       <chr>                          <chr>       <chr>           <dbl> <chr>             <chr>             <chr>              <chr>              <chr>           <dbl> <chr>             <chr>             <chr>              <chr>              <chr>                 <chr>              <chr>                 <chr>              <chr>        <dbl>          <dbl>               <dbl>               <dbl>                <dbl>                <dbl>                   <dbl>                <dbl>
##  1 051009                      554               19.2  061476001816 30665143037496           2764     21.6  30    3066514 3037496 S     Troy High                   Fullerton Joint Union High     Orange      635               325 309               95.08             295                90.77              646               229 227               99.13             228                99.56              291                   89.54              227                   99.13              2019-20       1281            554                 536                194.                  523                 190.                     518                 189.
##  2 050130                      461                8.22 060297000223 19642611930288           3454     14.5  19    1964261 1930288 S     Arcadia High                Arcadia Unified                Los Angeles 803               350 312               89.14             304                86.86              788               303 301               99.34             296                97.69              284                   81.14              294                   97.03              2019-20       1591            653                 613                188.                  600                 185.                     578                 178.
##  3 050748                      461                8.24 064128007894 19734601932862           3050     11.3  19    1973460 1932862 S     Diamond Bar High            Walnut Valley Unified          Los Angeles 713               378 348               92.06             331                87.57              625               259 255               98.46             254                98.07              318                   84.13              252                   97.30              2019-20       1338            637                 603                191.                  585                 186.                     570                 181.
##  4 052683                      425               36.4  062970010246 19648651995588           2574     45.7  19    1964865 1995588 S     Palos Verdes Peninsula High Palos Verdes Peninsula Unified Los Angeles 500               228 214               93.86             203                89.04              586               142 140               98.59             139                97.89              196                   85.96              137                   96.48              2019-20       1086            370                 354                192.                  342                 187.                     333                 182.
##  5 051984                      402               27.4  068450007067 30736503035102           2527     34.3  30    3073650 3035102 S     University High             Irvine Unified                 Orange      542               211 197               93.36             198                93.84              566               122 121               99.18             121                99.18              189                   89.57              120                   98.36              2019-20       1108            333                 318                193.                  319                 193.                     309                 188.
##  6 051283                      396               18.4  068450008251 30736503030657           2173     31.5  30    3073650 3030657 S     Northwood High              Irvine Unified                 Orange      502               182 167               91.76             170                93.41              523               160 158               98.75             159                99.38              162                   89.01              157                   98.13              2019-20       1025            342                 325                191.                  329                 193.                     319                 187.
##  7 051313                      360               41.8  061524001923 19645681932144           2693     53.8  19    1964568 1932144 S     Crescenta Valley High       Glendale Unified               Los Angeles 630               269 250               92.94             219                81.41              655               167 165               98.80             162                97.01              217                   80.67              162                   97.01              2019-20       1285            436                 415                192.                  381                 178.                     379                 178.
##  8 051267                      346               30.4  064015010994 30736430102871           2648     29.9  30    3073643 0102871 S     Arnold O. Beckman High      Tustin Unified                 Orange      678               273 253               92.67             231                84.62              756               193 190               98.45             190                98.45              224                   82.05              188                   97.41              2019-20       1434            466                 443                191.                  421                 183.                     412                 179.
##  9 053676                      338                6.77 064128006843 19734601939149           2754      8.10 19    1973460 1939149 S     Walnut High                 Walnut Valley Unified          Los Angeles 591               309 289               93.53             264                85.44              580               170 163               95.88             166                97.65              254                   82.20              162                   95.29              2019-20       1171            479                 452                189.                  430                 183.                     416                 177.
## 10 051895                      335               69.9  060002506328 19753331935808           2517     58.8  19    1975333 1935808 S     Mira Costa High             Manhattan Beach Unified        Los Angeles 681               266 257               96.62             233                87.59              640                96 96                100.00            95                 98.96              232                   87.22              95                    98.96              2019-20       1321            362                 353                197.                  328                 187.                     327                 186.
## # … with 350 more rows

Available variables:

  • Student lists
    • total_students_purchased
    • pct_white_purchased
  • NCES HS data
    • total_students
    • pct_white
  • CA DOE data
    • 12th graders: Enroll12 (enrolled), NumTSTTakr12 (# of testtakers), NumERWBenchmark12 (# met english benchmark), NumMathBenchmark12 (# met math benchmark)
    • 11th graders: Enroll11, NumTSTTakr11, NumERWBenchmark11, NumMathBenchmark11
    • 12th + 11th graders: Enroll1112, NumTSTTakr1112, NumERWBenchmark1112, NumMathBenchmark1112

Possible analysis:

  • Compare high school’s racial composition & test readiness against actual purchased students
  • Ideally, we’d be able to isolate purchased students by grad year/grade to match with secondary data for the same class of students
    • We weren’t able to do it for Urbana because some orders filtered for multiple graduating classes and there’s no grad_class column in the student-level data - that could be something we can try to request for
    • We’ll also need to update NCES data (e.g., different year’s data, use race variables by grade level) and check crosswalk

Potential questions/concerns:

  • If the characteristics of purchased students (e.g., racial composition, test readiness) do indeed differ from that of the high school for the same cohort/class of students, what are we able to conclude about why that is?
    • We will need to look at the order summary criteria to see what filters were being used
    • In the case of Urbana, the out-of-state orders filtered by geography (state, MSA, segment analysis), SAT/PSAT score ranges, and HS GPA (and sometimes separate orders for gender but both male/female were purchased)
    • In theory, all students who took the SAT who met the test score/GPA criteria and attended a HS that falls within the purchased geography/segment should be on the list
    • If a student from a purchased HS is not on the list, they either did not take the SAT/opt in or did not meet the test/GPA criteria
  • In other words, Urbana could not specifically pick students from the high school (apart from the filter criteria used), but they are specifically picking high schools to purchase through the segment analysis filter
    • It would be ideal to know the characteristics of the EN/HS clusters being purchased as compared to the clusters not purchased
    • We could try to look at purchased student-level data to infer characteristics of purchased EN/HS clusters, but without knowing the nonpurchased students, it would be hard to make comparisons/draw conclusions
    • Ideally we would be able to request the segment analysis info from the University